/*
 Navicat Premium Data Transfer

 Source Server         : js3
 Source Server Type    : MySQL
 Source Server Version : 50617
 Source Host           : ceshi.300c.cn:3306
 Source Schema         : tzsjj_sql

 Target Server Type    : MySQL
 Target Server Version : 50617
 File Encoding         : 65001

 Date: 22/08/2020 17:24:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cmf_assess
-- ----------------------------
DROP TABLE IF EXISTS `cmf_assess`;
CREATE TABLE `cmf_assess` (
  `assess_id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `personal_leave` int(11) DEFAULT NULL,
  `late` int(11) DEFAULT NULL,
  `abs` int(11) DEFAULT NULL,
  `sick_leave` int(11) DEFAULT NULL,
  `ear` int(11) DEFAULT NULL,
  `fraud` int(11) DEFAULT NULL,
  `cknl` varchar(255) DEFAULT NULL,
  `wcgz` varchar(255) DEFAULT NULL,
  `zxlh` varchar(255) DEFAULT NULL,
  `btl` varchar(255) DEFAULT NULL,
  `dota` int(11) DEFAULT NULL,
  `ywsp` int(11) DEFAULT NULL,
  `team` int(11) DEFAULT NULL,
  `report` int(11) DEFAULT NULL,
  `represe` int(11) DEFAULT NULL,
  `wanc` int(11) DEFAULT NULL,
  `zhil` int(11) DEFAULT NULL,
  `zj` int(11) DEFAULT NULL,
  `zjl` int(11) DEFAULT NULL,
  `commit` text,
  `time` char(11) NOT NULL,
  `zjpy` varchar(255) DEFAULT NULL,
  `zjlpy` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`assess_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_assess
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_asset
-- ----------------------------
DROP TABLE IF EXISTS `cmf_asset`;
CREATE TABLE `cmf_asset` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `file_size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小,单位B',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:可用,0:不可用',
  `download_times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下载次数',
  `file_key` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件惟一码',
  `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件名',
  `file_path` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件路径,相对于upload目录,可以为url',
  `file_md5` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件md5值',
  `file_sha1` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `suffix` varchar(10) NOT NULL DEFAULT '' COMMENT '文件后缀名,不包括点',
  `more` text COMMENT '其它详细信息,JSON格式',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='资源表';

-- ----------------------------
-- Records of cmf_asset
-- ----------------------------
BEGIN;
INSERT INTO `cmf_asset` VALUES (2, 1, 147371, 1597890160, 1, 0, 'b417eb0f1c79e606d72c000762bdd6b7e5b9db229927d606ac4b90445c6cdf4c', '54785d2ecb0034f8c30155850aab53bc.jpeg', 'admin/20200820/741bf5b28112b14ee01266b8fcd332c8.jpeg', 'b417eb0f1c79e606d72c000762bdd6b7', '7f07671b929b4ac45a290e18fdcbecffaacd25bc', 'jpeg', NULL);
COMMIT;

-- ----------------------------
-- Table structure for cmf_auth_access
-- ----------------------------
DROP TABLE IF EXISTS `cmf_auth_access`;
CREATE TABLE `cmf_auth_access` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL COMMENT '角色',
  `rule_name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '权限规则分类,请加应用前缀,如admin_',
  `company` int(10) NOT NULL COMMENT '公司id',
  `menu_id` int(20) NOT NULL COMMENT '原始菜单id',
  `access_versions_id` int(11) NOT NULL COMMENT '菜单版本id',
  `code` varchar(66) NOT NULL COMMENT '标记',
  PRIMARY KEY (`id`),
  KEY `role_id` (`role_id`),
  KEY `rule_name` (`rule_name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='权限授权表';

-- ----------------------------
-- Records of cmf_auth_access
-- ----------------------------
BEGIN;
INSERT INTO `cmf_auth_access` VALUES (1, 1, 'admin/Setting/default', '0', 85, 6, 10, '');
INSERT INTO `cmf_auth_access` VALUES (2, 1, 'admin/User/default', '0', 85, 49, 10, '');
INSERT INTO `cmf_auth_access` VALUES (3, 1, 'admin/Rbac/index', '1', 85, 50, 10, '');
INSERT INTO `cmf_auth_access` VALUES (4, 1, 'admin/Rbac/ajaxAdd', '2', 85, 51, 10, '');
INSERT INTO `cmf_auth_access` VALUES (5, 1, 'admin/Rbac/roleAddPost', '2', 85, 52, 10, '');
INSERT INTO `cmf_auth_access` VALUES (6, 1, 'admin/Rbac/ajaxEdit', '2', 85, 53, 10, '');
INSERT INTO `cmf_auth_access` VALUES (7, 1, 'admin/Rbac/ajaxEditPost', '2', 85, 54, 10, '');
INSERT INTO `cmf_auth_access` VALUES (8, 1, 'admin/Rbac/ajaxDelete', '2', 85, 55, 10, '');
INSERT INTO `cmf_auth_access` VALUES (9, 1, 'admin/Rbac/ajaxAuthorize', '2', 85, 56, 10, '');
INSERT INTO `cmf_auth_access` VALUES (10, 1, 'admin/Setting/password', '1', 85, 73, 10, '');
INSERT INTO `cmf_auth_access` VALUES (11, 1, 'admin/Setting/passwordPost', '2', 85, 74, 10, '');
INSERT INTO `cmf_auth_access` VALUES (12, 1, 'admin/Setting/clearCache', '1', 85, 77, 10, '');
INSERT INTO `cmf_auth_access` VALUES (13, 1, 'user/AdminIndex/default', '0', 85, 109, 10, '');
INSERT INTO `cmf_auth_access` VALUES (14, 1, 'admin/User/index', '1', 85, 110, 10, '');
INSERT INTO `cmf_auth_access` VALUES (15, 1, 'admin/User/add', '1', 85, 111, 10, '');
INSERT INTO `cmf_auth_access` VALUES (16, 1, 'admin/User/addPost', '2', 85, 112, 10, '');
INSERT INTO `cmf_auth_access` VALUES (17, 1, 'admin/User/edit', '1', 85, 113, 10, '');
INSERT INTO `cmf_auth_access` VALUES (18, 1, 'admin/User/editPost', '2', 85, 114, 10, '');
INSERT INTO `cmf_auth_access` VALUES (19, 1, 'admin/User/userInfo', '1', 85, 115, 10, '');
INSERT INTO `cmf_auth_access` VALUES (20, 1, 'admin/User/userInfoPost', '2', 85, 116, 10, '');
INSERT INTO `cmf_auth_access` VALUES (21, 1, 'admin/User/delete', '2', 85, 117, 10, '');
INSERT INTO `cmf_auth_access` VALUES (22, 1, 'admin/department/index', '1', 85, 162, 10, '');
INSERT INTO `cmf_auth_access` VALUES (23, 1, 'admin/Department/ajaxAdd', '2', 85, 165, 10, '');
INSERT INTO `cmf_auth_access` VALUES (24, 1, 'admin/Department/ajaxEdit', '2', 85, 166, 10, '');
INSERT INTO `cmf_auth_access` VALUES (25, 1, 'admin/department/ajaxEditPost', '2', 85, 167, 10, '');
INSERT INTO `cmf_auth_access` VALUES (26, 1, 'admin/Department/ajaxDelete', '2', 85, 168, 10, '');
INSERT INTO `cmf_auth_access` VALUES (27, 1, 'admin/Rbac/roleAdd', '1', 85, 182, 10, '');
INSERT INTO `cmf_auth_access` VALUES (28, 1, 'admin/Rbac/roleEdit', '1', 85, 183, 10, '');
INSERT INTO `cmf_auth_access` VALUES (29, 1, 'admin/Rbac/roleEditPost', '2', 85, 184, 10, '');
INSERT INTO `cmf_auth_access` VALUES (30, 1, 'admin/Rbac/roleDelete', '2', 85, 185, 10, '');
INSERT INTO `cmf_auth_access` VALUES (31, 1, 'admin/Rbac/authorize', '1', 85, 186, 10, '');
INSERT INTO `cmf_auth_access` VALUES (32, 1, 'admin/Rbac/authorizePost', '2', 85, 187, 10, '');
INSERT INTO `cmf_auth_access` VALUES (33, 1, 'admin/User/erwei', '2', 85, 201, 10, '');
INSERT INTO `cmf_auth_access` VALUES (34, 1, 'admin/Rbac/ajaxGetRoleMenu', '1', 85, 917, 10, '');
INSERT INTO `cmf_auth_access` VALUES (35, 1, 'admin/Rbac/ajax_role_menu_add', '2', 85, 918, 10, '');
INSERT INTO `cmf_auth_access` VALUES (36, 1, 'admin/AppDevelop/index', '1', 85, 1055, 10, '');
COMMIT;

-- ----------------------------
-- Table structure for cmf_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `cmf_auth_rule`;
CREATE TABLE `cmf_auth_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `app` varchar(15) NOT NULL COMMENT '规则所属module',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '权限规则分类，请加应用前缀,如admin_',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写',
  `param` varchar(100) NOT NULL DEFAULT '' COMMENT '额外url参数',
  `title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则描述',
  `condition` varchar(200) NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `module` (`app`,`status`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='权限规则表';

-- ----------------------------
-- Records of cmf_auth_rule
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_business_card
-- ----------------------------
DROP TABLE IF EXISTS `cmf_business_card`;
CREATE TABLE `cmf_business_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `add_time` int(11) NOT NULL COMMENT '添加时间',
  `modify_time` int(11) NOT NULL COMMENT '修改时间',
  `content` text NOT NULL COMMENT '内容',
  `sort` int(1) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_business_card
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_classify
-- ----------------------------
DROP TABLE IF EXISTS `cmf_classify`;
CREATE TABLE `cmf_classify` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `model_key` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '模块标识',
  `model_value` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '模块名称',
  `parent_class` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '大类',
  `sub_class` text CHARACTER SET utf8 NOT NULL COMMENT '子类',
  `classify_key` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '关键词',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of cmf_classify
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_company
-- ----------------------------
DROP TABLE IF EXISTS `cmf_company`;
CREATE TABLE `cmf_company` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司id',
  `company_name` varchar(255) NOT NULL COMMENT '公司名称',
  `company_num` varchar(255) NOT NULL COMMENT '公司组织代码',
  `parent_id` int(11) NOT NULL COMMENT '上级管理id',
  `status` int(1) NOT NULL COMMENT '状态;0:禁用,1:正常,2:未验证审核中，3:未通过审核',
  `company_type` int(3) NOT NULL COMMENT '所属行业',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `versions_type` int(11) NOT NULL DEFAULT '0' COMMENT '版本',
  `address` varchar(255) NOT NULL COMMENT '公司地址',
  `tel` varchar(20) NOT NULL COMMENT '公司电话',
  `url` varchar(255) NOT NULL COMMENT '网址',
  `remark` text NOT NULL COMMENT '备注',
  `company_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL COMMENT '管理员id',
  `super_admin` int(11) NOT NULL COMMENT '超管id',
  `super_login` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='公司表';

-- ----------------------------
-- Records of cmf_company
-- ----------------------------
BEGIN;
INSERT INTO `cmf_company` VALUES (1, '台州市审计局', '2019', 8, 1, 15, 1597826308, 10, '白云街道台州市政府2号楼', '15167620077', 'www.xx.cn', '申请通过！ 处理时间：2020年08月19日 16时38分38秒', 85, 282, 1, 'tzshenjiju');
COMMIT;

-- ----------------------------
-- Table structure for cmf_department
-- ----------------------------
DROP TABLE IF EXISTS `cmf_department`;
CREATE TABLE `cmf_department` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `department_NO` varchar(2) DEFAULT NULL COMMENT '部门编号 ',
  `status` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未激活，1已激活',
  `parent_id` int(10) NOT NULL DEFAULT '0' COMMENT '部门副ID',
  `list_order` int(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '部门名称',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `company_id` int(11) NOT NULL COMMENT '公司id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `department_No` (`department_NO`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of cmf_department
-- ----------------------------
BEGIN;
INSERT INTO `cmf_department` VALUES (1, '10', 1, 0, 0, '总部门', '总部门', 1);
INSERT INTO `cmf_department` VALUES (2, '15', 1, 1, 0, '整改督查处', '整改督查处', 1);
INSERT INTO `cmf_department` VALUES (3, '20', 1, 1, 0, '办公室', '', 1);
INSERT INTO `cmf_department` VALUES (4, '25', 1, 1, 0, '法规处', '', 1);
INSERT INTO `cmf_department` VALUES (5, '30', 1, 1, 0, '审计信息中心', '不包括业务人员', 1);
INSERT INTO `cmf_department` VALUES (6, '35', 1, 1, 0, '内审协会', '', 1);
INSERT INTO `cmf_department` VALUES (7, '40', 1, 1, 0, '经责处', '', 1);
INSERT INTO `cmf_department` VALUES (8, '45', 1, 1, 0, '财政处', '', 1);
INSERT INTO `cmf_department` VALUES (9, '50', 1, 1, 0, '行事处', '', 1);
INSERT INTO `cmf_department` VALUES (10, '55', 1, 1, 0, '农环处', '', 1);
INSERT INTO `cmf_department` VALUES (11, '60', 1, 1, 0, '企业处', '', 1);
INSERT INTO `cmf_department` VALUES (12, '65', 1, 1, 0, '固投处', '', 1);
COMMIT;

-- ----------------------------
-- Table structure for cmf_family
-- ----------------------------
DROP TABLE IF EXISTS `cmf_family`;
CREATE TABLE `cmf_family` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `talent_id` int(11) DEFAULT NULL COMMENT '人才管理id',
  `appellation` varchar(255) DEFAULT NULL COMMENT '称谓',
  `name` varchar(255) DEFAULT NULL COMMENT '姓名',
  `birthday` varchar(255) DEFAULT NULL COMMENT '出生日期',
  `political_outlook` varchar(255) DEFAULT NULL COMMENT '政治面貌',
  `job` varchar(255) DEFAULT NULL COMMENT '职位',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_family
-- ----------------------------
BEGIN;
INSERT INTO `cmf_family` VALUES (1, 1, '妻子', '小华', '1981.03', '中共党员', '台州市妇联干部');
INSERT INTO `cmf_family` VALUES (2, 1, '儿子', '小李', '2009.02', '群众', '椒江区实验小学学生');
INSERT INTO `cmf_family` VALUES (3, 1, '父亲', '小张', '1942.07', '群众', '天台县桐柏电力工程管理局(已退');
INSERT INTO `cmf_family` VALUES (4, 1, '母亲', '小小', '1946.03', '群众', '天台县始丰街道龙四村村民');
INSERT INTO `cmf_family` VALUES (5, 1, '', '', '', '', '');
INSERT INTO `cmf_family` VALUES (6, 1, '', '', '', '', '');
INSERT INTO `cmf_family` VALUES (7, 2, '妻子', '2号', '1981.03', '中共党员', '台州市妇联干部');
INSERT INTO `cmf_family` VALUES (8, 2, '儿子', '3号', '2009.02', '群众', '椒江区实验小学学生');
INSERT INTO `cmf_family` VALUES (9, 2, '儿子', '4号', '2015.05', '群众', '台州市枫南幼儿园学生');
INSERT INTO `cmf_family` VALUES (10, 2, '父亲', '5号', '1942.07', '群众', '天台县桐柏电力工程管理局(已退');
INSERT INTO `cmf_family` VALUES (11, 2, '母亲', '6号', '1946.03', '群众', '天台县始丰街道龙四村村民');
INSERT INTO `cmf_family` VALUES (12, 2, '', '', '', '', '');
COMMIT;

-- ----------------------------
-- Table structure for cmf_freight
-- ----------------------------
DROP TABLE IF EXISTS `cmf_freight`;
CREATE TABLE `cmf_freight` (
  `title` char(40) NOT NULL COMMENT '模板名称',
  `create_time` int(15) NOT NULL COMMENT '添加时间',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '计费规则(1.包邮 2.按件数)',
  `default_num` int(11) NOT NULL DEFAULT '1' COMMENT '默认首件',
  `default_price` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '默认首费',
  `continue_num` int(11) NOT NULL DEFAULT '1' COMMENT '续件',
  `continue_price` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '续费',
  `free_shipping` int(11) NOT NULL DEFAULT '0' COMMENT '满足几件包邮(包邮的状态下)',
  `store_id` varchar(20) NOT NULL DEFAULT '0' COMMENT '店铺id',
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_freight
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_freight_item
-- ----------------------------
DROP TABLE IF EXISTS `cmf_freight_item`;
CREATE TABLE `cmf_freight_item` (
  `freight_id` int(11) NOT NULL COMMENT '模板id',
  `first_num` int(11) NOT NULL DEFAULT '1' COMMENT '首件',
  `first_price` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '首费',
  `continue_num` int(11) NOT NULL DEFAULT '1' COMMENT '续件',
  `continue_price` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '续费',
  `create_time` int(11) NOT NULL COMMENT '添加时间',
  `area` text NOT NULL COMMENT '配送地区',
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='地区运费表';

-- ----------------------------
-- Records of cmf_freight_item
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_hook
-- ----------------------------
DROP TABLE IF EXISTS `cmf_hook`;
CREATE TABLE `cmf_hook` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '钩子类型(1:系统钩子;2:应用钩子;3:模板钩子)',
  `once` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否只允许一个插件运行(0:多个;1:一个)',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名称',
  `hook` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子',
  `app` varchar(15) NOT NULL DEFAULT '' COMMENT '应用名(只有应用钩子才用)',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COMMENT='系统钩子表';

-- ----------------------------
-- Records of cmf_hook
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_hook_plugin
-- ----------------------------
DROP TABLE IF EXISTS `cmf_hook_plugin`;
CREATE TABLE `cmf_hook_plugin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
  `hook` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名',
  `plugin` varchar(30) NOT NULL DEFAULT '' COMMENT '插件',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COMMENT='系统钩子插件表';

-- ----------------------------
-- Records of cmf_hook_plugin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_link
-- ----------------------------
DROP TABLE IF EXISTS `cmf_link`;
CREATE TABLE `cmf_link` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:不显示',
  `rating` int(11) NOT NULL DEFAULT '0' COMMENT '友情链接评级',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '友情链接描述',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '友情链接地址',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '友情链接名称',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT '友情链接图标',
  `target` varchar(10) NOT NULL DEFAULT '' COMMENT '友情链接打开方式',
  `rel` varchar(50) NOT NULL DEFAULT '' COMMENT '链接与网站的关系',
  PRIMARY KEY (`id`),
  KEY `link_visible` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='友情链接表';

-- ----------------------------
-- Records of cmf_link
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_nav
-- ----------------------------
DROP TABLE IF EXISTS `cmf_nav`;
CREATE TABLE `cmf_nav` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_main` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否为主导航;1:是;0:不是',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '导航位置名称',
  `remark` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='前台导航位置表';

-- ----------------------------
-- Records of cmf_nav
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_nav_menu
-- ----------------------------
DROP TABLE IF EXISTS `cmf_nav_menu`;
CREATE TABLE `cmf_nav_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nav_id` int(11) NOT NULL COMMENT '导航 id',
  `parent_id` int(11) NOT NULL COMMENT '父 id',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:隐藏',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
  `target` varchar(10) NOT NULL DEFAULT '' COMMENT '打开方式',
  `href` varchar(100) NOT NULL DEFAULT '' COMMENT '链接',
  `icon` varchar(20) NOT NULL DEFAULT '' COMMENT '图标',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '层级关系',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='前台导航菜单表';

-- ----------------------------
-- Records of cmf_nav_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_option
-- ----------------------------
DROP TABLE IF EXISTS `cmf_option`;
CREATE TABLE `cmf_option` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `autoload` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否自动加载;1:自动加载;0:不自动加载',
  `option_name` varchar(64) NOT NULL DEFAULT '' COMMENT '配置名',
  `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '配置值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `option_name` (`option_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='全站配置表';

-- ----------------------------
-- Records of cmf_option
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_plugin
-- ----------------------------
DROP TABLE IF EXISTS `cmf_plugin`;
CREATE TABLE `cmf_plugin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '插件类型;1:网站;8:微信',
  `has_admin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否有后台管理,0:没有;1:有',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:开启;0:禁用',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '插件安装时间',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '插件标识名,英文字母(惟一)',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '插件名称',
  `demo_url` varchar(50) NOT NULL DEFAULT '' COMMENT '演示地址，带协议',
  `hooks` varchar(255) NOT NULL DEFAULT '' COMMENT '实现的钩子;以“,”分隔',
  `author` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '插件作者',
  `author_url` varchar(50) NOT NULL DEFAULT '' COMMENT '作者网站链接',
  `version` varchar(20) NOT NULL DEFAULT '' COMMENT '插件版本号',
  `description` varchar(255) NOT NULL COMMENT '插件描述',
  `config` text COMMENT '插件配置',
  `module_menu_id` int(20) NOT NULL COMMENT '原始菜单id',
  `table_name` varchar(255) DEFAULT NULL COMMENT '提醒功能关联的表',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COMMENT='插件表';

-- ----------------------------
-- Records of cmf_plugin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_portal_category
-- ----------------------------
DROP TABLE IF EXISTS `cmf_portal_category`;
CREATE TABLE `cmf_portal_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类父id',
  `post_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类文章数',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `description` varchar(255) NOT NULL COMMENT '分类描述',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '分类层级关系路径',
  `seo_title` varchar(100) NOT NULL DEFAULT '',
  `seo_keywords` varchar(255) NOT NULL DEFAULT '',
  `seo_description` varchar(255) NOT NULL DEFAULT '',
  `list_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类列表模板',
  `one_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类文章页模板',
  `more` text COMMENT '扩展属性',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章分类表';

-- ----------------------------
-- Records of cmf_portal_category
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_portal_category_post
-- ----------------------------
DROP TABLE IF EXISTS `cmf_portal_category_post`;
CREATE TABLE `cmf_portal_category_post` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文章id',
  `category_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布',
  PRIMARY KEY (`id`),
  KEY `term_taxonomy_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='portal应用 分类文章对应表';

-- ----------------------------
-- Records of cmf_portal_category_post
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_portal_post
-- ----------------------------
DROP TABLE IF EXISTS `cmf_portal_post`;
CREATE TABLE `cmf_portal_post` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `post_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '类型,1:文章;2:页面',
  `post_format` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '内容格式;1:html;2:md',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '发表者用户id',
  `post_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:已发布;0:未发布;',
  `comment_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '评论状态;1:允许;0:不允许',
  `is_top` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶;1:置顶;0:不置顶',
  `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
  `post_hits` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '查看数',
  `post_like` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数',
  `comment_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `published_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  `post_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'post标题',
  `post_keywords` varchar(150) NOT NULL DEFAULT '' COMMENT 'seo keywords',
  `post_excerpt` varchar(500) NOT NULL DEFAULT '' COMMENT 'post摘要',
  `post_source` varchar(150) NOT NULL DEFAULT '' COMMENT '转载文章的来源',
  `post_content` text COMMENT '文章内容',
  `post_content_filtered` text COMMENT '处理过的文章内容',
  `more` text COMMENT '扩展属性,如缩略图;格式为json',
  PRIMARY KEY (`id`),
  KEY `type_status_date` (`post_type`,`post_status`,`create_time`,`id`),
  KEY `post_parent` (`parent_id`),
  KEY `post_author` (`user_id`),
  KEY `post_date` (`create_time`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='portal应用 文章表';

-- ----------------------------
-- Records of cmf_portal_post
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_portal_tag
-- ----------------------------
DROP TABLE IF EXISTS `cmf_portal_tag`;
CREATE TABLE `cmf_portal_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
  `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
  `post_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '标签文章数',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标签名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章标签表';

-- ----------------------------
-- Records of cmf_portal_tag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_portal_tag_post
-- ----------------------------
DROP TABLE IF EXISTS `cmf_portal_tag_post`;
CREATE TABLE `cmf_portal_tag_post` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tag_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '标签 id',
  `post_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文章 id',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布',
  PRIMARY KEY (`id`),
  KEY `term_taxonomy_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='portal应用 标签文章对应表';

-- ----------------------------
-- Records of cmf_portal_tag_post
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_receive
-- ----------------------------
DROP TABLE IF EXISTS `cmf_receive`;
CREATE TABLE `cmf_receive` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(200) NOT NULL,
  `user_name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_receive
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_recycle_bin
-- ----------------------------
DROP TABLE IF EXISTS `cmf_recycle_bin`;
CREATE TABLE `cmf_recycle_bin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `object_id` int(11) DEFAULT '0' COMMENT '删除内容 id',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `table_name` varchar(60) DEFAULT '' COMMENT '删除内容所在表名',
  `name` varchar(255) DEFAULT '' COMMENT '删除内容名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT=' 回收站';

-- ----------------------------
-- Records of cmf_recycle_bin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_role
-- ----------------------------
DROP TABLE IF EXISTS `cmf_role`;
CREATE TABLE `cmf_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父角色ID',
  `department_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '部门ID；默认为0，未分配',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态;0:禁用;1:正常',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `list_order` float NOT NULL DEFAULT '0' COMMENT '排序',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `company_id` int(11) DEFAULT '0' COMMENT '公司id',
  PRIMARY KEY (`id`),
  KEY `parentId` (`parent_id`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';

-- ----------------------------
-- Records of cmf_role
-- ----------------------------
BEGIN;
INSERT INTO `cmf_role` VALUES (1, 0, 1, 1, 1597887016, 0, 0, '局长', '', 1);
INSERT INTO `cmf_role` VALUES (2, 1, 1, 1, 1597889818, 0, 0, '副局长', '', 1);
INSERT INTO `cmf_role` VALUES (3, 2, 1, 1, 1597889862, 1597892631, 0, '主任', '', 1);
INSERT INTO `cmf_role` VALUES (4, 3, 2, 1, 1597889888, 1597892879, 0, '整改督查处成员', '', 1);
INSERT INTO `cmf_role` VALUES (5, 3, 3, 1, 1597892955, 0, 0, '办公室成员', '', 1);
INSERT INTO `cmf_role` VALUES (6, 3, 4, 1, 1597892976, 0, 0, '法规处成员', '', 1);
INSERT INTO `cmf_role` VALUES (7, 3, 5, 1, 1597892996, 0, 0, '审计信息中心成员', '', 1);
INSERT INTO `cmf_role` VALUES (8, 3, 6, 1, 1597893025, 0, 0, '内审协会成员', '', 1);
INSERT INTO `cmf_role` VALUES (9, 3, 7, 1, 1597893043, 0, 0, '经责处成员', '', 1);
INSERT INTO `cmf_role` VALUES (10, 3, 8, 1, 1597893063, 0, 0, '财政处成员', '', 1);
INSERT INTO `cmf_role` VALUES (11, 3, 9, 1, 1597893076, 0, 0, '行事处成员', '', 1);
INSERT INTO `cmf_role` VALUES (12, 3, 10, 1, 1597893095, 0, 0, '农环处成员', '', 1);
INSERT INTO `cmf_role` VALUES (13, 3, 11, 1, 1597893111, 0, 0, '企业处成员', '', 1);
INSERT INTO `cmf_role` VALUES (14, 3, 12, 1, 1597893139, 0, 0, '固投处成员', '', 1);
COMMIT;

-- ----------------------------
-- Table structure for cmf_route
-- ----------------------------
DROP TABLE IF EXISTS `cmf_route`;
CREATE TABLE `cmf_route` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '路由id',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态;1:启用,0:不启用',
  `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'URL规则类型;1:用户自定义;2:别名添加',
  `full_url` varchar(255) NOT NULL DEFAULT '' COMMENT '完整url',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '实际显示的url',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='url路由表';

-- ----------------------------
-- Records of cmf_route
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_slide
-- ----------------------------
DROP TABLE IF EXISTS `cmf_slide`;
CREATE TABLE `cmf_slide` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:显示,0不显示',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  `name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片分类',
  `remark` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '分类备注',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片表';

-- ----------------------------
-- Records of cmf_slide
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_slide_item
-- ----------------------------
DROP TABLE IF EXISTS `cmf_slide_item`;
CREATE TABLE `cmf_slide_item` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `slide_id` int(11) NOT NULL DEFAULT '0' COMMENT '幻灯片id',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:显示;0:隐藏',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '幻灯片名称',
  `image` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片图片',
  `url` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片链接',
  `target` varchar(10) NOT NULL DEFAULT '' COMMENT '友情链接打开方式',
  `description` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '幻灯片描述',
  `content` text CHARACTER SET utf8 COMMENT '幻灯片内容',
  `more` text COMMENT '链接打开方式',
  PRIMARY KEY (`id`),
  KEY `slide_cid` (`slide_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片子项表';

-- ----------------------------
-- Records of cmf_slide_item
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_sms_report
-- ----------------------------
DROP TABLE IF EXISTS `cmf_sms_report`;
CREATE TABLE `cmf_sms_report` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mobile` varchar(11) NOT NULL COMMENT '手机',
  `posttime` int(11) NOT NULL COMMENT '提交时间',
  `id_code` varchar(10) NOT NULL,
  `msg` varchar(90) DEFAULT NULL,
  `send_userid` mediumint(8) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `return_id` varchar(30) NOT NULL,
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_sms_report
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_sms_set
-- ----------------------------
DROP TABLE IF EXISTS `cmf_sms_set`;
CREATE TABLE `cmf_sms_set` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sms_id` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_sms_set
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_sys_logs
-- ----------------------------
DROP TABLE IF EXISTS `cmf_sys_logs`;
CREATE TABLE `cmf_sys_logs` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `status` varchar(5) DEFAULT NULL COMMENT '1 | 200 成功  else 失败',
  `user_type` tinyint(1) DEFAULT NULL COMMENT '1会员 2管理员',
  `event` varchar(255) DEFAULT NULL COMMENT '事件',
  `params` text NOT NULL COMMENT '请求参数',
  `add_time` int(11) DEFAULT NULL COMMENT '时间',
  `client_ip` varchar(50) DEFAULT NULL COMMENT 'ip',
  `uid` int(11) DEFAULT NULL COMMENT '用户id',
  `rk` text COMMENT '备注信息',
  `rule_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2021 DEFAULT CHARSET=utf8 COMMENT='系统日志表';

-- ----------------------------
-- Records of cmf_sys_logs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_sys_logs_config
-- ----------------------------
DROP TABLE IF EXISTS `cmf_sys_logs_config`;
CREATE TABLE `cmf_sys_logs_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rule` varchar(255) NOT NULL,
  `action_alias` varchar(50) NOT NULL,
  `param` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='系统日志配置';

-- ----------------------------
-- Records of cmf_sys_logs_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_talent_management
-- ----------------------------
DROP TABLE IF EXISTS `cmf_talent_management`;
CREATE TABLE `cmf_talent_management` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `birthday` varchar(20) DEFAULT NULL COMMENT '出生年月',
  `nation` varchar(10) DEFAULT NULL COMMENT '民族',
  `native_place` varchar(50) DEFAULT NULL COMMENT '籍贯',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `born_address` varchar(50) DEFAULT NULL COMMENT '出生地',
  `technology` varchar(100) DEFAULT NULL COMMENT '专业技术职位',
  `specialty` varchar(100) DEFAULT NULL COMMENT '特长',
  `full_time_schooling` varchar(255) DEFAULT NULL COMMENT '全日制教育(数组)',
  `graduate_school_one` varchar(255) DEFAULT NULL COMMENT '毕业院校(数组)',
  `online_schooling` varchar(255) DEFAULT NULL COMMENT '在职教育(数组)',
  `graduate_school_two` varchar(255) DEFAULT NULL COMMENT '毕业院校(数组)',
  `work_unit` varchar(255) DEFAULT NULL COMMENT '工作单位及职位',
  `resume` text COMMENT '简历',
  `rewards` text COMMENT '奖惩综述',
  `assessment` text COMMENT '年度考核综述',
  `company` varchar(255) DEFAULT NULL COMMENT '统计关系所在单位',
  `id_card` varchar(100) DEFAULT NULL COMMENT '身份证号',
  `manage_type` varchar(100) DEFAULT NULL COMMENT '管理类别',
  `person_type` varchar(100) DEFAULT NULL COMMENT '人员类别',
  `organization_type` varchar(100) DEFAULT NULL COMMENT '编织类别',
  `job_type` varchar(100) DEFAULT NULL COMMENT '职位类别',
  `leader_position` varchar(100) DEFAULT NULL COMMENT '现领导职位',
  `leader_position_time` varchar(100) DEFAULT NULL COMMENT '任现领导时间',
  `now_position` varchar(100) DEFAULT NULL COMMENT '现职级',
  `now_position_time` varchar(100) DEFAULT NULL COMMENT '任现职级时间',
  `position_level` varchar(100) DEFAULT NULL COMMENT ' 任相当层次',
  `job_rank_time` varchar(100) DEFAULT NULL COMMENT '职务职级时间',
  `add_time` int(20) DEFAULT NULL COMMENT '添加时间',
  `update_time` int(20) DEFAULT NULL COMMENT '修改时间',
  `update_person` varchar(20) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_talent_management
-- ----------------------------
BEGIN;
INSERT INTO `cmf_talent_management` VALUES (1, '小明', '男', '1921.9', '汉', '浙江台州', '', '浙江台州', '审计师', '审计', '大学,经济学学士', '浙江大学经济学,浙江大学经济学', ',', ',', '台州市审计局法规和审理处处长', '1995.09- 1999. 07    浙江大学经济 系经学\n1999.07--1999. 12    在家待业\n1999.12- -2001. 12   台州市天台县南屏乡政府\n2001. 12- 2006 08    台州市天 台县南屏乡团委书记\n2006. 08- 2006. 11   天台县委组织部组织科科员\n2006.11- 2009.12     台州市审计局科员\n2009.12- -2012. 12   台州市审计局副主任科员\n2012. 12- 2015. 12    台州市市计局经济 责任审计处副处长\n2015. 12- 2017.08     台州市审计局经济 责任审计处处长\n2017. 082019.05      台州市审计局法 规处长兼经济责任审计处长\n2019. 05--                 台州市审计局法规和审理处处长', '无', '2016年年度考核优秀: 2017年年度 考核优秀: 2018年年度考核优秀。', '', '', '', '', '', '', '', '', '', '', '', '', 1597992150, 1597992150, 'admin');
INSERT INTO `cmf_talent_management` VALUES (2, '1号', '女', '1998.09', '汉', '浙江台州', 'admin/20200820/741bf5b28112b14ee01266b8fcd332c8.jpeg', '浙江台州', '审计师', '审计', '大学,经济学博士', '浙江大学经济学,浙江大学经济学', ',', ',', '台州市审计局法规和审理处处长', '1995.09- 1999. 07    浙江大学经济 系经学\n1999.07--1999. 12    在家待业\n1999.12- -2001. 12   台州市天台县南屏乡政府\n2001. 12- 2006 08    台州市天 台县南屏乡团委书记\n2006. 08- 2006. 11   天台县委组织部组织科科员\n2006.11- 2009.12     台州市审计局科员\n2009.12- -2012. 12   台州市审计局副主任科员\n2012. 12- 2015. 12    台州市市计局经济 责任审计处副处长\n2015. 12- 2017.08     台州市审计局经济 责任审计处处长\n2017. 082019.05      台州市审计局法 规处长兼经济责任审计处长\n2019. 05--                 台州市审计局法规和审理处处长', '无', '2016年年度考核优秀: 2017年年度 考核优秀: 2018年年度考核优秀。', '台州市审计局', '332625197612290919', '其他', '公务员', '行政编制', '综合管路类', '乡科级正职', '2015.12', '', '', '', '', 1597992901, 1597992901, 'admin');
COMMIT;

-- ----------------------------
-- Table structure for cmf_theme
-- ----------------------------
DROP TABLE IF EXISTS `cmf_theme`;
CREATE TABLE `cmf_theme` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后升级时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '模板状态,1:正在使用;0:未使用',
  `is_compiled` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否为已编译模板',
  `theme` varchar(20) NOT NULL DEFAULT '' COMMENT '主题目录名，用于主题的维一标识',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '主题名称',
  `version` varchar(20) NOT NULL DEFAULT '' COMMENT '主题版本号',
  `demo_url` varchar(50) NOT NULL DEFAULT '' COMMENT '演示地址，带协议',
  `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图',
  `author` varchar(20) NOT NULL DEFAULT '' COMMENT '主题作者',
  `author_url` varchar(50) NOT NULL DEFAULT '' COMMENT '作者网站链接',
  `lang` varchar(10) NOT NULL DEFAULT '' COMMENT '支持语言',
  `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT '主题关键字',
  `description` varchar(100) NOT NULL DEFAULT '' COMMENT '主题描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_theme
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_theme_file
-- ----------------------------
DROP TABLE IF EXISTS `cmf_theme_file`;
CREATE TABLE `cmf_theme_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_public` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否公共的模板文件',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `theme` varchar(20) NOT NULL DEFAULT '' COMMENT '模板名称',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '模板文件名',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作',
  `file` varchar(50) NOT NULL DEFAULT '' COMMENT '模板文件，相对于模板根目录，如Portal/index.html',
  `description` varchar(100) NOT NULL DEFAULT '' COMMENT '模板文件描述',
  `more` text COMMENT '模板更多配置,用户自己后台设置的',
  `config_more` text COMMENT '模板更多配置,来源模板的配置文件',
  `draft_more` text COMMENT '模板更多配置,用户临时保存的配置',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=121 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_theme_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_third_party_user
-- ----------------------------
DROP TABLE IF EXISTS `cmf_third_party_user`;
CREATE TABLE `cmf_third_party_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '本站用户id',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'access_token过期时间',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '绑定时间',
  `login_times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:正常;0:禁用',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `third_party` varchar(20) NOT NULL DEFAULT '' COMMENT '第三方惟一码',
  `app_id` varchar(64) NOT NULL DEFAULT '' COMMENT '第三方应用 id',
  `last_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `access_token` varchar(512) NOT NULL DEFAULT '' COMMENT '第三方授权码',
  `openid` varchar(40) NOT NULL DEFAULT '' COMMENT '第三方用户id',
  `union_id` varchar(64) NOT NULL DEFAULT '' COMMENT '第三方用户多个产品中的惟一 id,(如:微信平台)',
  `more` text COMMENT '扩展信息',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='第三方用户表';

-- ----------------------------
-- Records of cmf_third_party_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user`;
CREATE TABLE `cmf_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(8) DEFAULT NULL COMMENT '员工编号',
  `user_type` tinyint(3) unsigned DEFAULT '1' COMMENT '用户类型;1:admin;2:会员',
  `sex` tinyint(2) DEFAULT '0' COMMENT '性别;0:保密,1:男,2:女',
  `birthday` varchar(20) DEFAULT '0' COMMENT '生日',
  `last_login_time` int(11) DEFAULT '0' COMMENT '最后登录时间',
  `score` int(11) DEFAULT '0' COMMENT '用户积分',
  `coin` int(10) unsigned DEFAULT '0' COMMENT '金币',
  `create_time` int(11) DEFAULT '0' COMMENT '注册时间',
  `user_status` tinyint(3) unsigned DEFAULT '1' COMMENT '用户状态;0:禁用,1:正常,2:未验证',
  `service` int(1) DEFAULT '0' COMMENT '1公司客服代表  ',
  `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户名',
  `user_pass` varchar(64) DEFAULT '' COMMENT '登录密码;cmf_password加密',
  `user_nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户昵称',
  `user_email` varchar(100) DEFAULT '' COMMENT '用户登录邮箱',
  `user_url` varchar(100) DEFAULT '' COMMENT '用户个人网址',
  `avatar` varchar(255) DEFAULT '' COMMENT '用户头像',
  `signature` varchar(255) DEFAULT '' COMMENT '个性签名',
  `last_login_ip` varchar(15) DEFAULT '' COMMENT '最后登录ip',
  `user_activation_key` varchar(60) DEFAULT '' COMMENT '激活码',
  `mobile` varchar(20) DEFAULT '' COMMENT '用户手机号',
  `more` text COMMENT '扩展属性',
  `sfz` varchar(200) DEFAULT NULL COMMENT '身份证',
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '联系地址',
  `sx_time` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '实习时间',
  `rz_time` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '入职时间',
  `fujian` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT '附件',
  `jiguan` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '籍贯',
  `xueli` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '学历',
  `byxy` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '毕业学校',
  `zhuanye` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '专业',
  `jjlianxi` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '紧急联系人',
  `bak` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT '备份',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '二维码链接地址',
  `yc_time` int(11) DEFAULT NULL COMMENT '延迟入职时间',
  `ry_token` varchar(255) DEFAULT NULL,
  `sign` varchar(255) DEFAULT NULL COMMENT '签名图片',
  `qq` varchar(25) DEFAULT NULL COMMENT '用户qq',
  `city` varchar(255) DEFAULT NULL COMMENT '城市',
  PRIMARY KEY (`id`),
  UNIQUE KEY `employee_id` (`employee_id`),
  KEY `user_login` (`user_login`),
  KEY `user_nickname` (`user_nickname`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of cmf_user
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user` VALUES (1, '10001001', 1, 0, '0', 1597970813, 0, 0, 1597826308, 1, 0, 'admin', '###8a5745e3d312f97f678853c603af8e90', '', '', '', '', '', '0.0.0.0', '', '15167620077', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL);
INSERT INTO `cmf_user` VALUES (3, '100861', 1, 1, '1994-05-22', 0, 0, 0, 0, 1, 0, '小明', '###8a5745e3d312f97f678853c603af8e90', '', '', '', 'admin/20200820/741bf5b28112b14ee01266b8fcd332c8.jpeg', '', '', '', '18668322793', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_action
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_action`;
CREATE TABLE `cmf_user_action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '更改积分，可以为负',
  `coin` int(11) NOT NULL DEFAULT '0' COMMENT '更改金币，可以为负',
  `reward_number` int(11) NOT NULL DEFAULT '0' COMMENT '奖励次数',
  `cycle_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '周期类型;0:不限;1:按天;2:按小时;3:永久',
  `cycle_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '周期时间值',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
  `app` varchar(50) NOT NULL DEFAULT '' COMMENT '操作所在应用名或插件名等',
  `url` text COMMENT '执行操作的url',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户操作表';

-- ----------------------------
-- Records of cmf_user_action
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_action_log
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_action_log`;
CREATE TABLE `cmf_user_action_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数',
  `last_visit_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后访问时间',
  `object` varchar(100) NOT NULL DEFAULT '' COMMENT '访问对象的id,格式:不带前缀的表名+id;如posts1表示xx_posts表里id为1的记录',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作名称;格式:应用名+控制器+操作名,也可自己定义格式只要不发生冲突且惟一;',
  `ip` varchar(15) NOT NULL DEFAULT '' COMMENT '用户ip',
  PRIMARY KEY (`id`),
  KEY `user_object_action` (`user_id`,`object`,`action`),
  KEY `user_object_action_ip` (`user_id`,`object`,`action`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='访问记录表';

-- ----------------------------
-- Records of cmf_user_action_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_attach
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_attach`;
CREATE TABLE `cmf_user_attach` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `company_id` int(11) NOT NULL COMMENT '公司id',
  `department_id` int(11) NOT NULL COMMENT '部门id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户附表，用于存储公司部门角色id与用户关联';

-- ----------------------------
-- Records of cmf_user_attach
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_attach` VALUES (1, 1, 1, 1, 1);
INSERT INTO `cmf_user_attach` VALUES (3, 3, 1, 3, 5);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_detail
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_detail`;
CREATE TABLE `cmf_user_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmf_user_detail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_favorite
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_favorite`;
CREATE TABLE `cmf_user_favorite` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户 id',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '收藏内容的标题',
  `url` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '收藏内容的原文地址，不带域名',
  `description` varchar(500) CHARACTER SET utf8 DEFAULT '' COMMENT '收藏内容的描述',
  `table_name` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '收藏实体以前所在表,不带前缀',
  `object_id` int(10) unsigned DEFAULT '0' COMMENT '收藏内容原来的主键id',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '收藏时间',
  PRIMARY KEY (`id`),
  KEY `uid` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='用户收藏表';

-- ----------------------------
-- Records of cmf_user_favorite
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_login_attempt
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_login_attempt`;
CREATE TABLE `cmf_user_login_attempt` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `login_attempts` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '尝试次数',
  `attempt_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '尝试登录时间',
  `locked_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '锁定时间',
  `ip` varchar(15) NOT NULL DEFAULT '' COMMENT '用户 ip',
  `account` varchar(100) NOT NULL DEFAULT '' COMMENT '用户账号,手机号,邮箱或用户名',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户登录尝试表';

-- ----------------------------
-- Records of cmf_user_login_attempt
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_score_log
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_score_log`;
CREATE TABLE `cmf_user_score_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户 id',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '更改积分，可以为负',
  `coin` int(11) NOT NULL DEFAULT '0' COMMENT '更改金币，可以为负',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='用户操作积分等奖励日志表';

-- ----------------------------
-- Records of cmf_user_score_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_token
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_token`;
CREATE TABLE `cmf_user_token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id',
  `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT ' 过期时间',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `token` varchar(64) NOT NULL DEFAULT '' COMMENT 'token',
  `device_type` varchar(10) NOT NULL DEFAULT '' COMMENT '设备类型;mobile,android,iphone,ipad,web,pc,mac,wxapp',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='用户客户端登录 token 表';

-- ----------------------------
-- Records of cmf_user_token
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_token` VALUES (12, 1, 1613522813, 1597970813, '21fbbc4aa0b2441b7c0e8928da5afcf9e01e47f409c76677284120b36bc72a31', 'web');
COMMIT;

-- ----------------------------
-- Table structure for cmf_verification_code
-- ----------------------------
DROP TABLE IF EXISTS `cmf_verification_code`;
CREATE TABLE `cmf_verification_code` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
  `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '当天已经发送成功的次数',
  `send_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后发送成功时间',
  `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证码过期时间',
  `code` varchar(8) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '最后发送成功的验证码',
  `account` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '手机号或者邮箱',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='手机邮箱数字验证码表';

-- ----------------------------
-- Records of cmf_verification_code
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
